Overview

Dataset Statistics

Number of Variables 19
Number of Rows 592733
Missing Cells 517326
Missing Cells (%) 4.6%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 510.9 MB
Average Row Size in Memory 903.9 B

Variable Types

Categorical 13
DateTime 1
Numerical 5

Variables

BidFeedbackId

categorical

Distinct Count 592733
Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Memory Size 57.1 MB

Length

Mean 36
Standard Deviation 0
Median 36
Minimum 36
Maximum 36

Sample

1st row 0000127c-9bad-4819...
2nd row 000015a8-ff10-4ea1...
3rd row 00001acf-180a-4677...
4th row 00002d58-6c07-4b8d...
5th row 00005440-1d42-4162...

Letter

Count 6967967
Lowercase Letter 6967967
Space Separator 0
Uppercase Letter 0
Dash Punctuation 2370932
Decimal Number 11999489

LogEntryTime

datetime

Distinct Count 10080
Unique (%) 1.7%
Missing 0
Missing (%) 0.0%
Memory Size 4.5 MB
Minimum 2019-01-02 00:00:00
Maximum 2019-07-02 23:59:00

CreativeId

categorical

Distinct Count 38117
Unique (%) 6.4%
Missing 0
Missing (%) 0.0%
Memory Size 41.3 MB

Length

Mean 8
Standard Deviation 0.001299
Median 8
Minimum 7
Maximum 8

Sample

1st row tiuunfez
2nd row gebhnrlx
3rd row tw5ju0fq
4th row adzprics
5th row myqmyec2

Letter

Count 3457955
Lowercase Letter 3457955
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 1283908

AdFormat

categorical

Distinct Count 55
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 40.5 MB

Length

Mean 6.7241
Standard Deviation 0.6527
Median 7
Minimum 3
Maximum 9

Sample

1st row 300x250
2nd row 728x90
3rd row 300x250
4th row 728x90
5th row 300x250

Letter

Count 592733
Lowercase Letter 592733
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 3392855

Frequency

numerical

Distinct Count 26
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 9.0 MB
Mean 1.6228
Minimum 0
Maximum 25
Zeros 411450
Zeros (%) 69.4%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 1
95-th Percentile 9
Maximum 25
Range 25
IQR 1

Descriptive Statistics

Mean 1.6228
Standard Deviation 4.6459
Variance 21.5847
Sum 961883
Skewness 4.0403
Kurtosis 16.3473
Coefficient of Variation 2.8629

WinningPriceCPMInBucks

numerical

Distinct Count 151053
Unique (%) 25.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 9.0 MB
Mean 3.1967
Minimum 0
Maximum 187.59
Zeros 105
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0.09548
Q1 0.4995
Median 1.4296
Q3 3.717
95-th Percentile 12.8
Maximum 187.59
Range 187.59
IQR 3.2175

Descriptive Statistics

Mean 3.1967
Standard Deviation 5.281
Variance 27.8894
Sum 1.8948e+06
Skewness 5.6983
Kurtosis 69.2474
Coefficient of Variation 1.652

site

categorical

Distinct Count 13762
Unique (%) 2.3%
Missing 0
Missing (%) 0.0%
Memory Size 45.5 MB

Length

Mean 15.5794
Standard Deviation 4.8524
Median 15
Minimum 1
Maximum 64

Sample

1st row 300048137
2nd row chicago.suntimes.c...
3rd row deadspin.com
4th row www.mathway.com
5th row quizlet.com

Letter

Count 7722317
Lowercase Letter 7722317
Space Separator 0
Uppercase Letter 0
Dash Punctuation 19752
Decimal Number 512129

ReferrerCategories

categorical

Distinct Count 10912
Unique (%) 2.4%
Missing 130998
Missing (%) 22.1%
Memory Size 33.3 MB

Length

Mean 10.6959
Standard Deviation 13.707
Median 3
Minimum 3
Maximum 500

Sample

1st row qrg,vas
2nd row jba
3rd row 3oc,h8k,6sj,68g,ql...
4th row i3l
5th row y29

Letter

Count 2821878
Lowercase Letter 2821878
Space Separator 0
Uppercase Letter 0
Dash Punctuation 111972
Decimal Number 1256854

DeviceType

categorical

Distinct Count 5
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 38.4 MB

Length

Mean 2.9938
Standard Deviation 1.7287
Median 2
Minimum 2
Maximum 11

Sample

1st row Mobile
2nd row PC
3rd row PC
4th row PC
5th row PC

Letter

Count 1774516
Lowercase Letter 736281
Space Separator 0
Uppercase Letter 1038235
Dash Punctuation 0
Decimal Number 0

OSFamily

categorical

Distinct Count 7
Unique (%) 0.0%
Missing 84
Missing (%) 0.0%
Memory Size 40.0 MB

Length

Mean 5.7118
Standard Deviation 1.8684
Median 7
Minimum 3
Maximum 12

Sample

1st row iOS
2nd row OSX
3rd row Windows
4th row Windows
5th row OSX

Letter

Count 3385088
Lowercase Letter 2508234
Space Separator 0
Uppercase Letter 876854
Dash Punctuation 0
Decimal Number 0

OS

categorical

Distinct Count 33
Unique (%) 0.0%
Missing 589
Missing (%) 0.1%
Memory Size 41.0 MB

Length

Mean 7.6763
Standard Deviation 1.7423
Median 9
Minimum 5
Maximum 14

Sample

1st row iOS121
2nd row Other
3rd row Windows10
4th row Windows10
5th row Other

Letter

Count 3537463
Lowercase Letter 2856540
Space Separator 0
Uppercase Letter 680923
Dash Punctuation 0
Decimal Number 1008012

Browser

categorical

Distinct Count 9
Unique (%) 0.0%
Missing 590
Missing (%) 0.1%
Memory Size 39.9 MB

Length

Mean 5.7389
Standard Deviation 1.6457
Median 6
Minimum 4
Maximum 18

Sample

1st row WebView
2nd row Chrome
3rd row Chrome
4th row Chrome
5th row Chrome

Letter

Count 3386211
Lowercase Letter 2700450
Space Separator 0
Uppercase Letter 685761
Dash Punctuation 0
Decimal Number 12060

RenderingContext

categorical

Distinct Count 3
Unique (%) 0.0%
Missing 8
Missing (%) 0.0%
Memory Size 40.1 MB

Length

Mean 5.9006
Standard Deviation 3.301
Median 5
Minimum 5
Maximum 18

Sample

1st row InApp
2nd row Other
3rd row Other
4th row Other
5th row Other

Letter

Count 3497431
Lowercase Letter 2756513
Space Separator 0
Uppercase Letter 740918
Dash Punctuation 0
Decimal Number 0

TemperatureInCelsius

numerical

Distinct Count 2101
Unique (%) 1.0%
Missing 385057
Missing (%) 65.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 3.2 MB
Mean 5.0138
Minimum -21.43
Maximum 26.09
Zeros 65
Zeros (%) 0.0%
Negatives 58122
Negatives (%) 9.8%

Quantile Statistics

Minimum -21.43
5-th Percentile -6.67
Q1 -0.6
Median 7.13
Q3 10.4
95-th Percentile 14.28
Maximum 26.09
Range 47.52
IQR 11

Descriptive Statistics

Mean 5.0138
Standard Deviation 6.6564
Variance 44.3072
Sum 1.0412e+06
Skewness -0.2927
Kurtosis -1.0272
Coefficient of Variation 1.3276

Location

categorical

Distinct Count 4
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 37.8 MB

Length

Mean 1.824
Standard Deviation 0.9844
Median 1
Minimum 1
Maximum 3

Sample

1st row ???
2nd row 1
3rd row ???
4th row ???
5th row 3

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 348532

TDID

numerical

Distinct Count 27660
Unique (%) 4.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 9.0 MB
Mean 296309.4217
Minimum 1
Maximum 592733
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 1
5-th Percentile 29814
Q1 149092
Median 297282
Q3 445187
95-th Percentile 563227
Maximum 592733
Range 592732
IQR 296095

Descriptive Statistics

Mean 296309.4217
Standard Deviation 171110.9211
Variance 2.9279e+10
Sum 1.7563e+11
Skewness 2.4741e-05
Kurtosis -1.2001
Coefficient of Variation 0.5775

Click

numerical

Distinct Count 2
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 9.0 MB
Mean 0.213
Minimum 0
Maximum 1
Zeros 466477
Zeros (%) 78.7%
Negatives 0
Negatives (%) 0.0%

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 1
Maximum 1
Range 1
IQR 0

Descriptive Statistics

Mean 0.213
Standard Deviation 0.4094
Variance 0.1676
Sum 126256
Skewness 1.4019
Kurtosis -0.03465
Coefficient of Variation 1.9222

day_of_week

categorical

Distinct Count 5
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 41.0 MB

Length

Mean 7.536
Standard Deviation 0.9542
Median 8
Minimum 6
Maximum 9

Sample

1st row Tuesday
2nd row Thursday
3rd row Wednesday
4th row Thursday
5th row Sunday

Letter

Count 4466824
Lowercase Letter 3874091
Space Separator 0
Uppercase Letter 592733
Dash Punctuation 0
Decimal Number 0

_site

categorical

Distinct Count 40
Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 41.5 MB

Length

Mean 8.4391
Standard Deviation 4.3795
Median 6
Minimum 6
Maximum 24

Sample

1st row Others
2nd row Others
3rd row Others
4th row Others
5th row quizlet.com

Letter

Count 4569340
Lowercase Letter 4147254
Space Separator 0
Uppercase Letter 422086
Dash Punctuation 3444
Decimal Number 138199

Interactions

Correlations

Missing Values